﻿CREATE TABLE [dbo].[Customer_Track] (
    [id]                     INT              IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [CustomerId]             UNIQUEIDENTIFIER NULL,
    [IntentionsId]           INT              NULL,
    [PublicityDemandId]      INT              NULL,
    [NetworkConsciousnessId] INT              NULL,
    [GenjinId]               INT              NULL,
    [Record]                 VARCHAR (MAX)    NULL,
    [UpName]                 NVARCHAR (50)    NULL,
    [UpTime]                 DATETIME         NULL,
    [DepartmentId]           INT              CONSTRAINT [DF_Customer_Track_DepartmentId] DEFAULT ((0)) NULL,
    [CompanyId]              INT              CONSTRAINT [DF_Customer_Track_CompanyId] DEFAULT ((0)) NULL,
    CONSTRAINT [PK_Customer_Track] PRIMARY KEY CLUSTERED ([id] ASC) WITH (FILLFACTOR = 90)
);


GO
CREATE NONCLUSTERED INDEX [IX_Customer_Track_CustID]
    ON [dbo].[Customer_Track]([CustomerId] ASC) WITH (FILLFACTOR = 90);


GO
CREATE NONCLUSTERED INDEX [IX_Customer_Track_UserID]
    ON [dbo].[Customer_Track]([UpName] ASC) WITH (FILLFACTOR = 90);

